# coding: utf-8
from . import db, BaseModel


class Student(BaseModel):
    __tablename__ = 'student'

    autoID = db.Column(db.Integer, primary_key=True)
    studentID = db.Column(db.String(20), info='学号')
    name = db.Column(db.String(20), info='学生姓名')
    age = db.Column(db.Integer, info='年龄')
    agenda = db.Column(db.String(10), info='性别')
    classID = db.Column(db.Integer, nullable=False, index=True, info='所属班级ID')
    isDelete = db.Column(db.Integer, server_default=db.FetchedValue(), info='是否删除')
    addTime = db.Column(db.DateTime, server_default=db.FetchedValue(), info='记录添加时间')
